29. Distribution Syle: Key
L03-08-OptimizingDesign-Part2 Distribution Syle- Key
Distribution Styles
QUIZ QUESTION::
Match each distribution style to its definition.
ANSWER CHOICES:
|
Definition |
Distribution Style |
|---|---|
Round-robin over all slices to achieve load-balancing. |
|
Small tables could be replicated on all slices to speed up joins. |
|
Allows Redshift to determine distribution style. |
|
Rows having similar values are placed in the same slice. |
SOLUTION:
|
Definition |
Distribution Style |
|---|---|
|
Rows having similar values are placed in the same slice. |
|
|
Small tables could be replicated on all slices to speed up joins. |
|
|
Allows Redshift to determine distribution style. |
|
|
Round-robin over all slices to achieve load-balancing. |